// 核销主表
const {DataTypes, db } = require("../db");
db.define('hx', {
id: {type: DataTypes.INTEGER, primaryKey: true, autoIncrement: true,comment:'表自增ID'},
tenantId:{type: DataTypes.INTEGER,allowNull:false,comment:''}, 
transTypeName:{type: DataTypes.STRING(20),allowNull:false,defaultValue:('核销单'),comment:''}, 
otherType:{type: DataTypes.STRING(20),allowNull:false,comment:'预收冲应收 预付冲应付'}, 
billNo:{type: DataTypes.STRING(30),comment:''}, 
billDate:{type: DataTypes.STRING(1),comment:''}, 
buId:{type: DataTypes.INTEGER,comment:''}, 
doId:{type: DataTypes.INTEGER,comment:''}, 
billState:{type: DataTypes.STRING(20),defaultValue:('draft'),comment:''}, 
bak1:{type: DataTypes.STRING(255),comment:''}, 
bak2:{type: DataTypes.STRING(255),comment:''}, 
dby:{type: DataTypes.STRING(255),comment:''}, 
cby:{type: DataTypes.INTEGER,comment:''}, 
createdAt:{type: DataTypes.STRING(20),comment:''}, 
updatedAt:{type: DataTypes.STRING(20),comment:''}, 

}, {
    tableName: 'hx',
    timestamps: false,
    comment: '核销主表'
});